package com.zhongwang.business.gen.entity;

import java.math.BigDecimal;
import java.util.ArrayList;
import java.util.Date;
import java.util.List;

public class BusMaterialDataExample {
    protected String orderByClause;

    protected boolean distinct;

    protected List<Criteria> oredCriteria;

    public BusMaterialDataExample() {
        oredCriteria = new ArrayList<Criteria>();
    }

    public void setOrderByClause(String orderByClause) {
        this.orderByClause = orderByClause;
    }

    public String getOrderByClause() {
        return orderByClause;
    }

    public void setDistinct(boolean distinct) {
        this.distinct = distinct;
    }

    public boolean isDistinct() {
        return distinct;
    }

    public List<Criteria> getOredCriteria() {
        return oredCriteria;
    }

    public void or(Criteria criteria) {
        oredCriteria.add(criteria);
    }

    public Criteria or() {
        Criteria criteria = createCriteriaInternal();
        oredCriteria.add(criteria);
        return criteria;
    }

    public Criteria createCriteria() {
        Criteria criteria = createCriteriaInternal();
        if (oredCriteria.size() == 0) {
            oredCriteria.add(criteria);
        }
        return criteria;
    }

    protected Criteria createCriteriaInternal() {
        Criteria criteria = new Criteria();
        return criteria;
    }

    public void clear() {
        oredCriteria.clear();
        orderByClause = null;
        distinct = false;
    }

    protected abstract static class GeneratedCriteria {
        protected List<Criterion> criteria;

        protected GeneratedCriteria() {
            super();
            criteria = new ArrayList<Criterion>();
        }

        public boolean isValid() {
            return criteria.size() > 0;
        }

        public List<Criterion> getAllCriteria() {
            return criteria;
        }

        public List<Criterion> getCriteria() {
            return criteria;
        }

        protected void addCriterion(String condition) {
            if (condition == null) {
                throw new RuntimeException("Value for condition cannot be null");
            }
            criteria.add(new Criterion(condition));
        }

        protected void addCriterion(String condition, Object value, String property) {
            if (value == null) {
                throw new RuntimeException("Value for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value));
        }

        protected void addCriterion(String condition, Object value1, Object value2, String property) {
            if (value1 == null || value2 == null) {
                throw new RuntimeException("Between values for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value1, value2));
        }

        public Criteria andIdIsNull() {
            addCriterion("id is null");
            return (Criteria) this;
        }

        public Criteria andIdIsNotNull() {
            addCriterion("id is not null");
            return (Criteria) this;
        }

        public Criteria andIdEqualTo(Integer value) {
            addCriterion("id =", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdNotEqualTo(Integer value) {
            addCriterion("id <>", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdGreaterThan(Integer value) {
            addCriterion("id >", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdGreaterThanOrEqualTo(Integer value) {
            addCriterion("id >=", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdLessThan(Integer value) {
            addCriterion("id <", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdLessThanOrEqualTo(Integer value) {
            addCriterion("id <=", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdIn(List<Integer> values) {
            addCriterion("id in", values, "id");
            return (Criteria) this;
        }

        public Criteria andIdNotIn(List<Integer> values) {
            addCriterion("id not in", values, "id");
            return (Criteria) this;
        }

        public Criteria andIdBetween(Integer value1, Integer value2) {
            addCriterion("id between", value1, value2, "id");
            return (Criteria) this;
        }

        public Criteria andIdNotBetween(Integer value1, Integer value2) {
            addCriterion("id not between", value1, value2, "id");
            return (Criteria) this;
        }

        public Criteria andResultIdIsNull() {
            addCriterion("result_id is null");
            return (Criteria) this;
        }

        public Criteria andResultIdIsNotNull() {
            addCriterion("result_id is not null");
            return (Criteria) this;
        }

        public Criteria andResultIdEqualTo(Integer value) {
            addCriterion("result_id =", value, "resultId");
            return (Criteria) this;
        }

        public Criteria andResultIdNotEqualTo(Integer value) {
            addCriterion("result_id <>", value, "resultId");
            return (Criteria) this;
        }

        public Criteria andResultIdGreaterThan(Integer value) {
            addCriterion("result_id >", value, "resultId");
            return (Criteria) this;
        }

        public Criteria andResultIdGreaterThanOrEqualTo(Integer value) {
            addCriterion("result_id >=", value, "resultId");
            return (Criteria) this;
        }

        public Criteria andResultIdLessThan(Integer value) {
            addCriterion("result_id <", value, "resultId");
            return (Criteria) this;
        }

        public Criteria andResultIdLessThanOrEqualTo(Integer value) {
            addCriterion("result_id <=", value, "resultId");
            return (Criteria) this;
        }

        public Criteria andResultIdIn(List<Integer> values) {
            addCriterion("result_id in", values, "resultId");
            return (Criteria) this;
        }

        public Criteria andResultIdNotIn(List<Integer> values) {
            addCriterion("result_id not in", values, "resultId");
            return (Criteria) this;
        }

        public Criteria andResultIdBetween(Integer value1, Integer value2) {
            addCriterion("result_id between", value1, value2, "resultId");
            return (Criteria) this;
        }

        public Criteria andResultIdNotBetween(Integer value1, Integer value2) {
            addCriterion("result_id not between", value1, value2, "resultId");
            return (Criteria) this;
        }

        public Criteria andRppIdIsNull() {
            addCriterion("rpp_id is null");
            return (Criteria) this;
        }

        public Criteria andRppIdIsNotNull() {
            addCriterion("rpp_id is not null");
            return (Criteria) this;
        }

        public Criteria andRppIdEqualTo(Integer value) {
            addCriterion("rpp_id =", value, "rppId");
            return (Criteria) this;
        }

        public Criteria andRppIdNotEqualTo(Integer value) {
            addCriterion("rpp_id <>", value, "rppId");
            return (Criteria) this;
        }

        public Criteria andRppIdGreaterThan(Integer value) {
            addCriterion("rpp_id >", value, "rppId");
            return (Criteria) this;
        }

        public Criteria andRppIdGreaterThanOrEqualTo(Integer value) {
            addCriterion("rpp_id >=", value, "rppId");
            return (Criteria) this;
        }

        public Criteria andRppIdLessThan(Integer value) {
            addCriterion("rpp_id <", value, "rppId");
            return (Criteria) this;
        }

        public Criteria andRppIdLessThanOrEqualTo(Integer value) {
            addCriterion("rpp_id <=", value, "rppId");
            return (Criteria) this;
        }

        public Criteria andRppIdIn(List<Integer> values) {
            addCriterion("rpp_id in", values, "rppId");
            return (Criteria) this;
        }

        public Criteria andRppIdNotIn(List<Integer> values) {
            addCriterion("rpp_id not in", values, "rppId");
            return (Criteria) this;
        }

        public Criteria andRppIdBetween(Integer value1, Integer value2) {
            addCriterion("rpp_id between", value1, value2, "rppId");
            return (Criteria) this;
        }

        public Criteria andRppIdNotBetween(Integer value1, Integer value2) {
            addCriterion("rpp_id not between", value1, value2, "rppId");
            return (Criteria) this;
        }

        public Criteria andBatIdIsNull() {
            addCriterion("bat_id is null");
            return (Criteria) this;
        }

        public Criteria andBatIdIsNotNull() {
            addCriterion("bat_id is not null");
            return (Criteria) this;
        }

        public Criteria andBatIdEqualTo(Integer value) {
            addCriterion("bat_id =", value, "batId");
            return (Criteria) this;
        }

        public Criteria andBatIdNotEqualTo(Integer value) {
            addCriterion("bat_id <>", value, "batId");
            return (Criteria) this;
        }

        public Criteria andBatIdGreaterThan(Integer value) {
            addCriterion("bat_id >", value, "batId");
            return (Criteria) this;
        }

        public Criteria andBatIdGreaterThanOrEqualTo(Integer value) {
            addCriterion("bat_id >=", value, "batId");
            return (Criteria) this;
        }

        public Criteria andBatIdLessThan(Integer value) {
            addCriterion("bat_id <", value, "batId");
            return (Criteria) this;
        }

        public Criteria andBatIdLessThanOrEqualTo(Integer value) {
            addCriterion("bat_id <=", value, "batId");
            return (Criteria) this;
        }

        public Criteria andBatIdIn(List<Integer> values) {
            addCriterion("bat_id in", values, "batId");
            return (Criteria) this;
        }

        public Criteria andBatIdNotIn(List<Integer> values) {
            addCriterion("bat_id not in", values, "batId");
            return (Criteria) this;
        }

        public Criteria andBatIdBetween(Integer value1, Integer value2) {
            addCriterion("bat_id between", value1, value2, "batId");
            return (Criteria) this;
        }

        public Criteria andBatIdNotBetween(Integer value1, Integer value2) {
            addCriterion("bat_id not between", value1, value2, "batId");
            return (Criteria) this;
        }

        public Criteria andMatDescIsNull() {
            addCriterion("mat_desc is null");
            return (Criteria) this;
        }

        public Criteria andMatDescIsNotNull() {
            addCriterion("mat_desc is not null");
            return (Criteria) this;
        }

        public Criteria andMatDescEqualTo(String value) {
            addCriterion("mat_desc =", value, "matDesc");
            return (Criteria) this;
        }

        public Criteria andMatDescNotEqualTo(String value) {
            addCriterion("mat_desc <>", value, "matDesc");
            return (Criteria) this;
        }

        public Criteria andMatDescGreaterThan(String value) {
            addCriterion("mat_desc >", value, "matDesc");
            return (Criteria) this;
        }

        public Criteria andMatDescGreaterThanOrEqualTo(String value) {
            addCriterion("mat_desc >=", value, "matDesc");
            return (Criteria) this;
        }

        public Criteria andMatDescLessThan(String value) {
            addCriterion("mat_desc <", value, "matDesc");
            return (Criteria) this;
        }

        public Criteria andMatDescLessThanOrEqualTo(String value) {
            addCriterion("mat_desc <=", value, "matDesc");
            return (Criteria) this;
        }

        public Criteria andMatDescLike(String value) {
            addCriterion("mat_desc like", value, "matDesc");
            return (Criteria) this;
        }

        public Criteria andMatDescNotLike(String value) {
            addCriterion("mat_desc not like", value, "matDesc");
            return (Criteria) this;
        }

        public Criteria andMatDescIn(List<String> values) {
            addCriterion("mat_desc in", values, "matDesc");
            return (Criteria) this;
        }

        public Criteria andMatDescNotIn(List<String> values) {
            addCriterion("mat_desc not in", values, "matDesc");
            return (Criteria) this;
        }

        public Criteria andMatDescBetween(String value1, String value2) {
            addCriterion("mat_desc between", value1, value2, "matDesc");
            return (Criteria) this;
        }

        public Criteria andMatDescNotBetween(String value1, String value2) {
            addCriterion("mat_desc not between", value1, value2, "matDesc");
            return (Criteria) this;
        }

        public Criteria andNumIsNull() {
            addCriterion("num is null");
            return (Criteria) this;
        }

        public Criteria andNumIsNotNull() {
            addCriterion("num is not null");
            return (Criteria) this;
        }

        public Criteria andNumEqualTo(BigDecimal value) {
            addCriterion("num =", value, "num");
            return (Criteria) this;
        }

        public Criteria andNumNotEqualTo(BigDecimal value) {
            addCriterion("num <>", value, "num");
            return (Criteria) this;
        }

        public Criteria andNumGreaterThan(BigDecimal value) {
            addCriterion("num >", value, "num");
            return (Criteria) this;
        }

        public Criteria andNumGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("num >=", value, "num");
            return (Criteria) this;
        }

        public Criteria andNumLessThan(BigDecimal value) {
            addCriterion("num <", value, "num");
            return (Criteria) this;
        }

        public Criteria andNumLessThanOrEqualTo(BigDecimal value) {
            addCriterion("num <=", value, "num");
            return (Criteria) this;
        }

        public Criteria andNumIn(List<BigDecimal> values) {
            addCriterion("num in", values, "num");
            return (Criteria) this;
        }

        public Criteria andNumNotIn(List<BigDecimal> values) {
            addCriterion("num not in", values, "num");
            return (Criteria) this;
        }

        public Criteria andNumBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("num between", value1, value2, "num");
            return (Criteria) this;
        }

        public Criteria andNumNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("num not between", value1, value2, "num");
            return (Criteria) this;
        }

        public Criteria andUnitIsNull() {
            addCriterion("unit is null");
            return (Criteria) this;
        }

        public Criteria andUnitIsNotNull() {
            addCriterion("unit is not null");
            return (Criteria) this;
        }

        public Criteria andUnitEqualTo(String value) {
            addCriterion("unit =", value, "unit");
            return (Criteria) this;
        }

        public Criteria andUnitNotEqualTo(String value) {
            addCriterion("unit <>", value, "unit");
            return (Criteria) this;
        }

        public Criteria andUnitGreaterThan(String value) {
            addCriterion("unit >", value, "unit");
            return (Criteria) this;
        }

        public Criteria andUnitGreaterThanOrEqualTo(String value) {
            addCriterion("unit >=", value, "unit");
            return (Criteria) this;
        }

        public Criteria andUnitLessThan(String value) {
            addCriterion("unit <", value, "unit");
            return (Criteria) this;
        }

        public Criteria andUnitLessThanOrEqualTo(String value) {
            addCriterion("unit <=", value, "unit");
            return (Criteria) this;
        }

        public Criteria andUnitLike(String value) {
            addCriterion("unit like", value, "unit");
            return (Criteria) this;
        }

        public Criteria andUnitNotLike(String value) {
            addCriterion("unit not like", value, "unit");
            return (Criteria) this;
        }

        public Criteria andUnitIn(List<String> values) {
            addCriterion("unit in", values, "unit");
            return (Criteria) this;
        }

        public Criteria andUnitNotIn(List<String> values) {
            addCriterion("unit not in", values, "unit");
            return (Criteria) this;
        }

        public Criteria andUnitBetween(String value1, String value2) {
            addCriterion("unit between", value1, value2, "unit");
            return (Criteria) this;
        }

        public Criteria andUnitNotBetween(String value1, String value2) {
            addCriterion("unit not between", value1, value2, "unit");
            return (Criteria) this;
        }

        public Criteria andStandardNoIsNull() {
            addCriterion("standard_no is null");
            return (Criteria) this;
        }

        public Criteria andStandardNoIsNotNull() {
            addCriterion("standard_no is not null");
            return (Criteria) this;
        }

        public Criteria andStandardNoEqualTo(String value) {
            addCriterion("standard_no =", value, "standardNo");
            return (Criteria) this;
        }

        public Criteria andStandardNoNotEqualTo(String value) {
            addCriterion("standard_no <>", value, "standardNo");
            return (Criteria) this;
        }

        public Criteria andStandardNoGreaterThan(String value) {
            addCriterion("standard_no >", value, "standardNo");
            return (Criteria) this;
        }

        public Criteria andStandardNoGreaterThanOrEqualTo(String value) {
            addCriterion("standard_no >=", value, "standardNo");
            return (Criteria) this;
        }

        public Criteria andStandardNoLessThan(String value) {
            addCriterion("standard_no <", value, "standardNo");
            return (Criteria) this;
        }

        public Criteria andStandardNoLessThanOrEqualTo(String value) {
            addCriterion("standard_no <=", value, "standardNo");
            return (Criteria) this;
        }

        public Criteria andStandardNoLike(String value) {
            addCriterion("standard_no like", value, "standardNo");
            return (Criteria) this;
        }

        public Criteria andStandardNoNotLike(String value) {
            addCriterion("standard_no not like", value, "standardNo");
            return (Criteria) this;
        }

        public Criteria andStandardNoIn(List<String> values) {
            addCriterion("standard_no in", values, "standardNo");
            return (Criteria) this;
        }

        public Criteria andStandardNoNotIn(List<String> values) {
            addCriterion("standard_no not in", values, "standardNo");
            return (Criteria) this;
        }

        public Criteria andStandardNoBetween(String value1, String value2) {
            addCriterion("standard_no between", value1, value2, "standardNo");
            return (Criteria) this;
        }

        public Criteria andStandardNoNotBetween(String value1, String value2) {
            addCriterion("standard_no not between", value1, value2, "standardNo");
            return (Criteria) this;
        }

        public Criteria andBrandIsNull() {
            addCriterion("brand is null");
            return (Criteria) this;
        }

        public Criteria andBrandIsNotNull() {
            addCriterion("brand is not null");
            return (Criteria) this;
        }

        public Criteria andBrandEqualTo(String value) {
            addCriterion("brand =", value, "brand");
            return (Criteria) this;
        }

        public Criteria andBrandNotEqualTo(String value) {
            addCriterion("brand <>", value, "brand");
            return (Criteria) this;
        }

        public Criteria andBrandGreaterThan(String value) {
            addCriterion("brand >", value, "brand");
            return (Criteria) this;
        }

        public Criteria andBrandGreaterThanOrEqualTo(String value) {
            addCriterion("brand >=", value, "brand");
            return (Criteria) this;
        }

        public Criteria andBrandLessThan(String value) {
            addCriterion("brand <", value, "brand");
            return (Criteria) this;
        }

        public Criteria andBrandLessThanOrEqualTo(String value) {
            addCriterion("brand <=", value, "brand");
            return (Criteria) this;
        }

        public Criteria andBrandLike(String value) {
            addCriterion("brand like", value, "brand");
            return (Criteria) this;
        }

        public Criteria andBrandNotLike(String value) {
            addCriterion("brand not like", value, "brand");
            return (Criteria) this;
        }

        public Criteria andBrandIn(List<String> values) {
            addCriterion("brand in", values, "brand");
            return (Criteria) this;
        }

        public Criteria andBrandNotIn(List<String> values) {
            addCriterion("brand not in", values, "brand");
            return (Criteria) this;
        }

        public Criteria andBrandBetween(String value1, String value2) {
            addCriterion("brand between", value1, value2, "brand");
            return (Criteria) this;
        }

        public Criteria andBrandNotBetween(String value1, String value2) {
            addCriterion("brand not between", value1, value2, "brand");
            return (Criteria) this;
        }

        public Criteria andRemarkIsNull() {
            addCriterion("remark is null");
            return (Criteria) this;
        }

        public Criteria andRemarkIsNotNull() {
            addCriterion("remark is not null");
            return (Criteria) this;
        }

        public Criteria andRemarkEqualTo(String value) {
            addCriterion("remark =", value, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkNotEqualTo(String value) {
            addCriterion("remark <>", value, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkGreaterThan(String value) {
            addCriterion("remark >", value, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkGreaterThanOrEqualTo(String value) {
            addCriterion("remark >=", value, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkLessThan(String value) {
            addCriterion("remark <", value, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkLessThanOrEqualTo(String value) {
            addCriterion("remark <=", value, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkLike(String value) {
            addCriterion("remark like", value, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkNotLike(String value) {
            addCriterion("remark not like", value, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkIn(List<String> values) {
            addCriterion("remark in", values, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkNotIn(List<String> values) {
            addCriterion("remark not in", values, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkBetween(String value1, String value2) {
            addCriterion("remark between", value1, value2, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkNotBetween(String value1, String value2) {
            addCriterion("remark not between", value1, value2, "remark");
            return (Criteria) this;
        }

        public Criteria andDiagramIsNull() {
            addCriterion("diagram is null");
            return (Criteria) this;
        }

        public Criteria andDiagramIsNotNull() {
            addCriterion("diagram is not null");
            return (Criteria) this;
        }

        public Criteria andDiagramEqualTo(String value) {
            addCriterion("diagram =", value, "diagram");
            return (Criteria) this;
        }

        public Criteria andDiagramNotEqualTo(String value) {
            addCriterion("diagram <>", value, "diagram");
            return (Criteria) this;
        }

        public Criteria andDiagramGreaterThan(String value) {
            addCriterion("diagram >", value, "diagram");
            return (Criteria) this;
        }

        public Criteria andDiagramGreaterThanOrEqualTo(String value) {
            addCriterion("diagram >=", value, "diagram");
            return (Criteria) this;
        }

        public Criteria andDiagramLessThan(String value) {
            addCriterion("diagram <", value, "diagram");
            return (Criteria) this;
        }

        public Criteria andDiagramLessThanOrEqualTo(String value) {
            addCriterion("diagram <=", value, "diagram");
            return (Criteria) this;
        }

        public Criteria andDiagramLike(String value) {
            addCriterion("diagram like", value, "diagram");
            return (Criteria) this;
        }

        public Criteria andDiagramNotLike(String value) {
            addCriterion("diagram not like", value, "diagram");
            return (Criteria) this;
        }

        public Criteria andDiagramIn(List<String> values) {
            addCriterion("diagram in", values, "diagram");
            return (Criteria) this;
        }

        public Criteria andDiagramNotIn(List<String> values) {
            addCriterion("diagram not in", values, "diagram");
            return (Criteria) this;
        }

        public Criteria andDiagramBetween(String value1, String value2) {
            addCriterion("diagram between", value1, value2, "diagram");
            return (Criteria) this;
        }

        public Criteria andDiagramNotBetween(String value1, String value2) {
            addCriterion("diagram not between", value1, value2, "diagram");
            return (Criteria) this;
        }

        public Criteria andAssistTypeIsNull() {
            addCriterion("assist_type is null");
            return (Criteria) this;
        }

        public Criteria andAssistTypeIsNotNull() {
            addCriterion("assist_type is not null");
            return (Criteria) this;
        }

        public Criteria andAssistTypeEqualTo(String value) {
            addCriterion("assist_type =", value, "assistType");
            return (Criteria) this;
        }

        public Criteria andAssistTypeNotEqualTo(String value) {
            addCriterion("assist_type <>", value, "assistType");
            return (Criteria) this;
        }

        public Criteria andAssistTypeGreaterThan(String value) {
            addCriterion("assist_type >", value, "assistType");
            return (Criteria) this;
        }

        public Criteria andAssistTypeGreaterThanOrEqualTo(String value) {
            addCriterion("assist_type >=", value, "assistType");
            return (Criteria) this;
        }

        public Criteria andAssistTypeLessThan(String value) {
            addCriterion("assist_type <", value, "assistType");
            return (Criteria) this;
        }

        public Criteria andAssistTypeLessThanOrEqualTo(String value) {
            addCriterion("assist_type <=", value, "assistType");
            return (Criteria) this;
        }

        public Criteria andAssistTypeLike(String value) {
            addCriterion("assist_type like", value, "assistType");
            return (Criteria) this;
        }

        public Criteria andAssistTypeNotLike(String value) {
            addCriterion("assist_type not like", value, "assistType");
            return (Criteria) this;
        }

        public Criteria andAssistTypeIn(List<String> values) {
            addCriterion("assist_type in", values, "assistType");
            return (Criteria) this;
        }

        public Criteria andAssistTypeNotIn(List<String> values) {
            addCriterion("assist_type not in", values, "assistType");
            return (Criteria) this;
        }

        public Criteria andAssistTypeBetween(String value1, String value2) {
            addCriterion("assist_type between", value1, value2, "assistType");
            return (Criteria) this;
        }

        public Criteria andAssistTypeNotBetween(String value1, String value2) {
            addCriterion("assist_type not between", value1, value2, "assistType");
            return (Criteria) this;
        }

        public Criteria andPartIsNull() {
            addCriterion("part is null");
            return (Criteria) this;
        }

        public Criteria andPartIsNotNull() {
            addCriterion("part is not null");
            return (Criteria) this;
        }

        public Criteria andPartEqualTo(String value) {
            addCriterion("part =", value, "part");
            return (Criteria) this;
        }

        public Criteria andPartNotEqualTo(String value) {
            addCriterion("part <>", value, "part");
            return (Criteria) this;
        }

        public Criteria andPartGreaterThan(String value) {
            addCriterion("part >", value, "part");
            return (Criteria) this;
        }

        public Criteria andPartGreaterThanOrEqualTo(String value) {
            addCriterion("part >=", value, "part");
            return (Criteria) this;
        }

        public Criteria andPartLessThan(String value) {
            addCriterion("part <", value, "part");
            return (Criteria) this;
        }

        public Criteria andPartLessThanOrEqualTo(String value) {
            addCriterion("part <=", value, "part");
            return (Criteria) this;
        }

        public Criteria andPartLike(String value) {
            addCriterion("part like", value, "part");
            return (Criteria) this;
        }

        public Criteria andPartNotLike(String value) {
            addCriterion("part not like", value, "part");
            return (Criteria) this;
        }

        public Criteria andPartIn(List<String> values) {
            addCriterion("part in", values, "part");
            return (Criteria) this;
        }

        public Criteria andPartNotIn(List<String> values) {
            addCriterion("part not in", values, "part");
            return (Criteria) this;
        }

        public Criteria andPartBetween(String value1, String value2) {
            addCriterion("part between", value1, value2, "part");
            return (Criteria) this;
        }

        public Criteria andPartNotBetween(String value1, String value2) {
            addCriterion("part not between", value1, value2, "part");
            return (Criteria) this;
        }

        public Criteria andMajorIsNull() {
            addCriterion("major is null");
            return (Criteria) this;
        }

        public Criteria andMajorIsNotNull() {
            addCriterion("major is not null");
            return (Criteria) this;
        }

        public Criteria andMajorEqualTo(String value) {
            addCriterion("major =", value, "major");
            return (Criteria) this;
        }

        public Criteria andMajorNotEqualTo(String value) {
            addCriterion("major <>", value, "major");
            return (Criteria) this;
        }

        public Criteria andMajorGreaterThan(String value) {
            addCriterion("major >", value, "major");
            return (Criteria) this;
        }

        public Criteria andMajorGreaterThanOrEqualTo(String value) {
            addCriterion("major >=", value, "major");
            return (Criteria) this;
        }

        public Criteria andMajorLessThan(String value) {
            addCriterion("major <", value, "major");
            return (Criteria) this;
        }

        public Criteria andMajorLessThanOrEqualTo(String value) {
            addCriterion("major <=", value, "major");
            return (Criteria) this;
        }

        public Criteria andMajorLike(String value) {
            addCriterion("major like", value, "major");
            return (Criteria) this;
        }

        public Criteria andMajorNotLike(String value) {
            addCriterion("major not like", value, "major");
            return (Criteria) this;
        }

        public Criteria andMajorIn(List<String> values) {
            addCriterion("major in", values, "major");
            return (Criteria) this;
        }

        public Criteria andMajorNotIn(List<String> values) {
            addCriterion("major not in", values, "major");
            return (Criteria) this;
        }

        public Criteria andMajorBetween(String value1, String value2) {
            addCriterion("major between", value1, value2, "major");
            return (Criteria) this;
        }

        public Criteria andMajorNotBetween(String value1, String value2) {
            addCriterion("major not between", value1, value2, "major");
            return (Criteria) this;
        }

        public Criteria andBuyTypeIsNull() {
            addCriterion("buy_type is null");
            return (Criteria) this;
        }

        public Criteria andBuyTypeIsNotNull() {
            addCriterion("buy_type is not null");
            return (Criteria) this;
        }

        public Criteria andBuyTypeEqualTo(String value) {
            addCriterion("buy_type =", value, "buyType");
            return (Criteria) this;
        }

        public Criteria andBuyTypeNotEqualTo(String value) {
            addCriterion("buy_type <>", value, "buyType");
            return (Criteria) this;
        }

        public Criteria andBuyTypeGreaterThan(String value) {
            addCriterion("buy_type >", value, "buyType");
            return (Criteria) this;
        }

        public Criteria andBuyTypeGreaterThanOrEqualTo(String value) {
            addCriterion("buy_type >=", value, "buyType");
            return (Criteria) this;
        }

        public Criteria andBuyTypeLessThan(String value) {
            addCriterion("buy_type <", value, "buyType");
            return (Criteria) this;
        }

        public Criteria andBuyTypeLessThanOrEqualTo(String value) {
            addCriterion("buy_type <=", value, "buyType");
            return (Criteria) this;
        }

        public Criteria andBuyTypeLike(String value) {
            addCriterion("buy_type like", value, "buyType");
            return (Criteria) this;
        }

        public Criteria andBuyTypeNotLike(String value) {
            addCriterion("buy_type not like", value, "buyType");
            return (Criteria) this;
        }

        public Criteria andBuyTypeIn(List<String> values) {
            addCriterion("buy_type in", values, "buyType");
            return (Criteria) this;
        }

        public Criteria andBuyTypeNotIn(List<String> values) {
            addCriterion("buy_type not in", values, "buyType");
            return (Criteria) this;
        }

        public Criteria andBuyTypeBetween(String value1, String value2) {
            addCriterion("buy_type between", value1, value2, "buyType");
            return (Criteria) this;
        }

        public Criteria andBuyTypeNotBetween(String value1, String value2) {
            addCriterion("buy_type not between", value1, value2, "buyType");
            return (Criteria) this;
        }

        public Criteria andMalTypeIsNull() {
            addCriterion("mal_type is null");
            return (Criteria) this;
        }

        public Criteria andMalTypeIsNotNull() {
            addCriterion("mal_type is not null");
            return (Criteria) this;
        }

        public Criteria andMalTypeEqualTo(String value) {
            addCriterion("mal_type =", value, "malType");
            return (Criteria) this;
        }

        public Criteria andMalTypeNotEqualTo(String value) {
            addCriterion("mal_type <>", value, "malType");
            return (Criteria) this;
        }

        public Criteria andMalTypeGreaterThan(String value) {
            addCriterion("mal_type >", value, "malType");
            return (Criteria) this;
        }

        public Criteria andMalTypeGreaterThanOrEqualTo(String value) {
            addCriterion("mal_type >=", value, "malType");
            return (Criteria) this;
        }

        public Criteria andMalTypeLessThan(String value) {
            addCriterion("mal_type <", value, "malType");
            return (Criteria) this;
        }

        public Criteria andMalTypeLessThanOrEqualTo(String value) {
            addCriterion("mal_type <=", value, "malType");
            return (Criteria) this;
        }

        public Criteria andMalTypeLike(String value) {
            addCriterion("mal_type like", value, "malType");
            return (Criteria) this;
        }

        public Criteria andMalTypeNotLike(String value) {
            addCriterion("mal_type not like", value, "malType");
            return (Criteria) this;
        }

        public Criteria andMalTypeIn(List<String> values) {
            addCriterion("mal_type in", values, "malType");
            return (Criteria) this;
        }

        public Criteria andMalTypeNotIn(List<String> values) {
            addCriterion("mal_type not in", values, "malType");
            return (Criteria) this;
        }

        public Criteria andMalTypeBetween(String value1, String value2) {
            addCriterion("mal_type between", value1, value2, "malType");
            return (Criteria) this;
        }

        public Criteria andMalTypeNotBetween(String value1, String value2) {
            addCriterion("mal_type not between", value1, value2, "malType");
            return (Criteria) this;
        }

        public Criteria andPriceIsNull() {
            addCriterion("price is null");
            return (Criteria) this;
        }

        public Criteria andPriceIsNotNull() {
            addCriterion("price is not null");
            return (Criteria) this;
        }

        public Criteria andPriceEqualTo(BigDecimal value) {
            addCriterion("price =", value, "price");
            return (Criteria) this;
        }

        public Criteria andPriceNotEqualTo(BigDecimal value) {
            addCriterion("price <>", value, "price");
            return (Criteria) this;
        }

        public Criteria andPriceGreaterThan(BigDecimal value) {
            addCriterion("price >", value, "price");
            return (Criteria) this;
        }

        public Criteria andPriceGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("price >=", value, "price");
            return (Criteria) this;
        }

        public Criteria andPriceLessThan(BigDecimal value) {
            addCriterion("price <", value, "price");
            return (Criteria) this;
        }

        public Criteria andPriceLessThanOrEqualTo(BigDecimal value) {
            addCriterion("price <=", value, "price");
            return (Criteria) this;
        }

        public Criteria andPriceIn(List<BigDecimal> values) {
            addCriterion("price in", values, "price");
            return (Criteria) this;
        }

        public Criteria andPriceNotIn(List<BigDecimal> values) {
            addCriterion("price not in", values, "price");
            return (Criteria) this;
        }

        public Criteria andPriceBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("price between", value1, value2, "price");
            return (Criteria) this;
        }

        public Criteria andPriceNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("price not between", value1, value2, "price");
            return (Criteria) this;
        }

        public Criteria andTextureIsNull() {
            addCriterion("texture is null");
            return (Criteria) this;
        }

        public Criteria andTextureIsNotNull() {
            addCriterion("texture is not null");
            return (Criteria) this;
        }

        public Criteria andTextureEqualTo(String value) {
            addCriterion("texture =", value, "texture");
            return (Criteria) this;
        }

        public Criteria andTextureNotEqualTo(String value) {
            addCriterion("texture <>", value, "texture");
            return (Criteria) this;
        }

        public Criteria andTextureGreaterThan(String value) {
            addCriterion("texture >", value, "texture");
            return (Criteria) this;
        }

        public Criteria andTextureGreaterThanOrEqualTo(String value) {
            addCriterion("texture >=", value, "texture");
            return (Criteria) this;
        }

        public Criteria andTextureLessThan(String value) {
            addCriterion("texture <", value, "texture");
            return (Criteria) this;
        }

        public Criteria andTextureLessThanOrEqualTo(String value) {
            addCriterion("texture <=", value, "texture");
            return (Criteria) this;
        }

        public Criteria andTextureLike(String value) {
            addCriterion("texture like", value, "texture");
            return (Criteria) this;
        }

        public Criteria andTextureNotLike(String value) {
            addCriterion("texture not like", value, "texture");
            return (Criteria) this;
        }

        public Criteria andTextureIn(List<String> values) {
            addCriterion("texture in", values, "texture");
            return (Criteria) this;
        }

        public Criteria andTextureNotIn(List<String> values) {
            addCriterion("texture not in", values, "texture");
            return (Criteria) this;
        }

        public Criteria andTextureBetween(String value1, String value2) {
            addCriterion("texture between", value1, value2, "texture");
            return (Criteria) this;
        }

        public Criteria andTextureNotBetween(String value1, String value2) {
            addCriterion("texture not between", value1, value2, "texture");
            return (Criteria) this;
        }

        public Criteria andSapCodeIsNull() {
            addCriterion("sap_code is null");
            return (Criteria) this;
        }

        public Criteria andSapCodeIsNotNull() {
            addCriterion("sap_code is not null");
            return (Criteria) this;
        }

        public Criteria andSapCodeEqualTo(String value) {
            addCriterion("sap_code =", value, "sapCode");
            return (Criteria) this;
        }

        public Criteria andSapCodeNotEqualTo(String value) {
            addCriterion("sap_code <>", value, "sapCode");
            return (Criteria) this;
        }

        public Criteria andSapCodeGreaterThan(String value) {
            addCriterion("sap_code >", value, "sapCode");
            return (Criteria) this;
        }

        public Criteria andSapCodeGreaterThanOrEqualTo(String value) {
            addCriterion("sap_code >=", value, "sapCode");
            return (Criteria) this;
        }

        public Criteria andSapCodeLessThan(String value) {
            addCriterion("sap_code <", value, "sapCode");
            return (Criteria) this;
        }

        public Criteria andSapCodeLessThanOrEqualTo(String value) {
            addCriterion("sap_code <=", value, "sapCode");
            return (Criteria) this;
        }

        public Criteria andSapCodeLike(String value) {
            addCriterion("sap_code like", value, "sapCode");
            return (Criteria) this;
        }

        public Criteria andSapCodeNotLike(String value) {
            addCriterion("sap_code not like", value, "sapCode");
            return (Criteria) this;
        }

        public Criteria andSapCodeIn(List<String> values) {
            addCriterion("sap_code in", values, "sapCode");
            return (Criteria) this;
        }

        public Criteria andSapCodeNotIn(List<String> values) {
            addCriterion("sap_code not in", values, "sapCode");
            return (Criteria) this;
        }

        public Criteria andSapCodeBetween(String value1, String value2) {
            addCriterion("sap_code between", value1, value2, "sapCode");
            return (Criteria) this;
        }

        public Criteria andSapCodeNotBetween(String value1, String value2) {
            addCriterion("sap_code not between", value1, value2, "sapCode");
            return (Criteria) this;
        }

        public Criteria andDsIdIsNull() {
            addCriterion("ds_id is null");
            return (Criteria) this;
        }

        public Criteria andDsIdIsNotNull() {
            addCriterion("ds_id is not null");
            return (Criteria) this;
        }

        public Criteria andDsIdEqualTo(Integer value) {
            addCriterion("ds_id =", value, "dsId");
            return (Criteria) this;
        }

        public Criteria andDsIdNotEqualTo(Integer value) {
            addCriterion("ds_id <>", value, "dsId");
            return (Criteria) this;
        }

        public Criteria andDsIdGreaterThan(Integer value) {
            addCriterion("ds_id >", value, "dsId");
            return (Criteria) this;
        }

        public Criteria andDsIdGreaterThanOrEqualTo(Integer value) {
            addCriterion("ds_id >=", value, "dsId");
            return (Criteria) this;
        }

        public Criteria andDsIdLessThan(Integer value) {
            addCriterion("ds_id <", value, "dsId");
            return (Criteria) this;
        }

        public Criteria andDsIdLessThanOrEqualTo(Integer value) {
            addCriterion("ds_id <=", value, "dsId");
            return (Criteria) this;
        }

        public Criteria andDsIdIn(List<Integer> values) {
            addCriterion("ds_id in", values, "dsId");
            return (Criteria) this;
        }

        public Criteria andDsIdNotIn(List<Integer> values) {
            addCriterion("ds_id not in", values, "dsId");
            return (Criteria) this;
        }

        public Criteria andDsIdBetween(Integer value1, Integer value2) {
            addCriterion("ds_id between", value1, value2, "dsId");
            return (Criteria) this;
        }

        public Criteria andDsIdNotBetween(Integer value1, Integer value2) {
            addCriterion("ds_id not between", value1, value2, "dsId");
            return (Criteria) this;
        }

        public Criteria andUseTypeIsNull() {
            addCriterion("use_type is null");
            return (Criteria) this;
        }

        public Criteria andUseTypeIsNotNull() {
            addCriterion("use_type is not null");
            return (Criteria) this;
        }

        public Criteria andUseTypeEqualTo(Integer value) {
            addCriterion("use_type =", value, "useType");
            return (Criteria) this;
        }

        public Criteria andUseTypeNotEqualTo(Integer value) {
            addCriterion("use_type <>", value, "useType");
            return (Criteria) this;
        }

        public Criteria andUseTypeGreaterThan(Integer value) {
            addCriterion("use_type >", value, "useType");
            return (Criteria) this;
        }

        public Criteria andUseTypeGreaterThanOrEqualTo(Integer value) {
            addCriterion("use_type >=", value, "useType");
            return (Criteria) this;
        }

        public Criteria andUseTypeLessThan(Integer value) {
            addCriterion("use_type <", value, "useType");
            return (Criteria) this;
        }

        public Criteria andUseTypeLessThanOrEqualTo(Integer value) {
            addCriterion("use_type <=", value, "useType");
            return (Criteria) this;
        }

        public Criteria andUseTypeIn(List<Integer> values) {
            addCriterion("use_type in", values, "useType");
            return (Criteria) this;
        }

        public Criteria andUseTypeNotIn(List<Integer> values) {
            addCriterion("use_type not in", values, "useType");
            return (Criteria) this;
        }

        public Criteria andUseTypeBetween(Integer value1, Integer value2) {
            addCriterion("use_type between", value1, value2, "useType");
            return (Criteria) this;
        }

        public Criteria andUseTypeNotBetween(Integer value1, Integer value2) {
            addCriterion("use_type not between", value1, value2, "useType");
            return (Criteria) this;
        }

        public Criteria andProCodeIsNull() {
            addCriterion("pro_code is null");
            return (Criteria) this;
        }

        public Criteria andProCodeIsNotNull() {
            addCriterion("pro_code is not null");
            return (Criteria) this;
        }

        public Criteria andProCodeEqualTo(String value) {
            addCriterion("pro_code =", value, "proCode");
            return (Criteria) this;
        }

        public Criteria andProCodeNotEqualTo(String value) {
            addCriterion("pro_code <>", value, "proCode");
            return (Criteria) this;
        }

        public Criteria andProCodeGreaterThan(String value) {
            addCriterion("pro_code >", value, "proCode");
            return (Criteria) this;
        }

        public Criteria andProCodeGreaterThanOrEqualTo(String value) {
            addCriterion("pro_code >=", value, "proCode");
            return (Criteria) this;
        }

        public Criteria andProCodeLessThan(String value) {
            addCriterion("pro_code <", value, "proCode");
            return (Criteria) this;
        }

        public Criteria andProCodeLessThanOrEqualTo(String value) {
            addCriterion("pro_code <=", value, "proCode");
            return (Criteria) this;
        }

        public Criteria andProCodeLike(String value) {
            addCriterion("pro_code like", value, "proCode");
            return (Criteria) this;
        }

        public Criteria andProCodeNotLike(String value) {
            addCriterion("pro_code not like", value, "proCode");
            return (Criteria) this;
        }

        public Criteria andProCodeIn(List<String> values) {
            addCriterion("pro_code in", values, "proCode");
            return (Criteria) this;
        }

        public Criteria andProCodeNotIn(List<String> values) {
            addCriterion("pro_code not in", values, "proCode");
            return (Criteria) this;
        }

        public Criteria andProCodeBetween(String value1, String value2) {
            addCriterion("pro_code between", value1, value2, "proCode");
            return (Criteria) this;
        }

        public Criteria andProCodeNotBetween(String value1, String value2) {
            addCriterion("pro_code not between", value1, value2, "proCode");
            return (Criteria) this;
        }

        public Criteria andBuyMatDescIsNull() {
            addCriterion("buy_mat_desc is null");
            return (Criteria) this;
        }

        public Criteria andBuyMatDescIsNotNull() {
            addCriterion("buy_mat_desc is not null");
            return (Criteria) this;
        }

        public Criteria andBuyMatDescEqualTo(String value) {
            addCriterion("buy_mat_desc =", value, "buyMatDesc");
            return (Criteria) this;
        }

        public Criteria andBuyMatDescNotEqualTo(String value) {
            addCriterion("buy_mat_desc <>", value, "buyMatDesc");
            return (Criteria) this;
        }

        public Criteria andBuyMatDescGreaterThan(String value) {
            addCriterion("buy_mat_desc >", value, "buyMatDesc");
            return (Criteria) this;
        }

        public Criteria andBuyMatDescGreaterThanOrEqualTo(String value) {
            addCriterion("buy_mat_desc >=", value, "buyMatDesc");
            return (Criteria) this;
        }

        public Criteria andBuyMatDescLessThan(String value) {
            addCriterion("buy_mat_desc <", value, "buyMatDesc");
            return (Criteria) this;
        }

        public Criteria andBuyMatDescLessThanOrEqualTo(String value) {
            addCriterion("buy_mat_desc <=", value, "buyMatDesc");
            return (Criteria) this;
        }

        public Criteria andBuyMatDescLike(String value) {
            addCriterion("buy_mat_desc like", value, "buyMatDesc");
            return (Criteria) this;
        }

        public Criteria andBuyMatDescNotLike(String value) {
            addCriterion("buy_mat_desc not like", value, "buyMatDesc");
            return (Criteria) this;
        }

        public Criteria andBuyMatDescIn(List<String> values) {
            addCriterion("buy_mat_desc in", values, "buyMatDesc");
            return (Criteria) this;
        }

        public Criteria andBuyMatDescNotIn(List<String> values) {
            addCriterion("buy_mat_desc not in", values, "buyMatDesc");
            return (Criteria) this;
        }

        public Criteria andBuyMatDescBetween(String value1, String value2) {
            addCriterion("buy_mat_desc between", value1, value2, "buyMatDesc");
            return (Criteria) this;
        }

        public Criteria andBuyMatDescNotBetween(String value1, String value2) {
            addCriterion("buy_mat_desc not between", value1, value2, "buyMatDesc");
            return (Criteria) this;
        }

        public Criteria andBuyNumIsNull() {
            addCriterion("buy_num is null");
            return (Criteria) this;
        }

        public Criteria andBuyNumIsNotNull() {
            addCriterion("buy_num is not null");
            return (Criteria) this;
        }

        public Criteria andBuyNumEqualTo(BigDecimal value) {
            addCriterion("buy_num =", value, "buyNum");
            return (Criteria) this;
        }

        public Criteria andBuyNumNotEqualTo(BigDecimal value) {
            addCriterion("buy_num <>", value, "buyNum");
            return (Criteria) this;
        }

        public Criteria andBuyNumGreaterThan(BigDecimal value) {
            addCriterion("buy_num >", value, "buyNum");
            return (Criteria) this;
        }

        public Criteria andBuyNumGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("buy_num >=", value, "buyNum");
            return (Criteria) this;
        }

        public Criteria andBuyNumLessThan(BigDecimal value) {
            addCriterion("buy_num <", value, "buyNum");
            return (Criteria) this;
        }

        public Criteria andBuyNumLessThanOrEqualTo(BigDecimal value) {
            addCriterion("buy_num <=", value, "buyNum");
            return (Criteria) this;
        }

        public Criteria andBuyNumIn(List<BigDecimal> values) {
            addCriterion("buy_num in", values, "buyNum");
            return (Criteria) this;
        }

        public Criteria andBuyNumNotIn(List<BigDecimal> values) {
            addCriterion("buy_num not in", values, "buyNum");
            return (Criteria) this;
        }

        public Criteria andBuyNumBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("buy_num between", value1, value2, "buyNum");
            return (Criteria) this;
        }

        public Criteria andBuyNumNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("buy_num not between", value1, value2, "buyNum");
            return (Criteria) this;
        }

        public Criteria andBuyUnitIsNull() {
            addCriterion("buy_unit is null");
            return (Criteria) this;
        }

        public Criteria andBuyUnitIsNotNull() {
            addCriterion("buy_unit is not null");
            return (Criteria) this;
        }

        public Criteria andBuyUnitEqualTo(String value) {
            addCriterion("buy_unit =", value, "buyUnit");
            return (Criteria) this;
        }

        public Criteria andBuyUnitNotEqualTo(String value) {
            addCriterion("buy_unit <>", value, "buyUnit");
            return (Criteria) this;
        }

        public Criteria andBuyUnitGreaterThan(String value) {
            addCriterion("buy_unit >", value, "buyUnit");
            return (Criteria) this;
        }

        public Criteria andBuyUnitGreaterThanOrEqualTo(String value) {
            addCriterion("buy_unit >=", value, "buyUnit");
            return (Criteria) this;
        }

        public Criteria andBuyUnitLessThan(String value) {
            addCriterion("buy_unit <", value, "buyUnit");
            return (Criteria) this;
        }

        public Criteria andBuyUnitLessThanOrEqualTo(String value) {
            addCriterion("buy_unit <=", value, "buyUnit");
            return (Criteria) this;
        }

        public Criteria andBuyUnitLike(String value) {
            addCriterion("buy_unit like", value, "buyUnit");
            return (Criteria) this;
        }

        public Criteria andBuyUnitNotLike(String value) {
            addCriterion("buy_unit not like", value, "buyUnit");
            return (Criteria) this;
        }

        public Criteria andBuyUnitIn(List<String> values) {
            addCriterion("buy_unit in", values, "buyUnit");
            return (Criteria) this;
        }

        public Criteria andBuyUnitNotIn(List<String> values) {
            addCriterion("buy_unit not in", values, "buyUnit");
            return (Criteria) this;
        }

        public Criteria andBuyUnitBetween(String value1, String value2) {
            addCriterion("buy_unit between", value1, value2, "buyUnit");
            return (Criteria) this;
        }

        public Criteria andBuyUnitNotBetween(String value1, String value2) {
            addCriterion("buy_unit not between", value1, value2, "buyUnit");
            return (Criteria) this;
        }

        public Criteria andBuyStandardNoIsNull() {
            addCriterion("buy_standard_no is null");
            return (Criteria) this;
        }

        public Criteria andBuyStandardNoIsNotNull() {
            addCriterion("buy_standard_no is not null");
            return (Criteria) this;
        }

        public Criteria andBuyStandardNoEqualTo(String value) {
            addCriterion("buy_standard_no =", value, "buyStandardNo");
            return (Criteria) this;
        }

        public Criteria andBuyStandardNoNotEqualTo(String value) {
            addCriterion("buy_standard_no <>", value, "buyStandardNo");
            return (Criteria) this;
        }

        public Criteria andBuyStandardNoGreaterThan(String value) {
            addCriterion("buy_standard_no >", value, "buyStandardNo");
            return (Criteria) this;
        }

        public Criteria andBuyStandardNoGreaterThanOrEqualTo(String value) {
            addCriterion("buy_standard_no >=", value, "buyStandardNo");
            return (Criteria) this;
        }

        public Criteria andBuyStandardNoLessThan(String value) {
            addCriterion("buy_standard_no <", value, "buyStandardNo");
            return (Criteria) this;
        }

        public Criteria andBuyStandardNoLessThanOrEqualTo(String value) {
            addCriterion("buy_standard_no <=", value, "buyStandardNo");
            return (Criteria) this;
        }

        public Criteria andBuyStandardNoLike(String value) {
            addCriterion("buy_standard_no like", value, "buyStandardNo");
            return (Criteria) this;
        }

        public Criteria andBuyStandardNoNotLike(String value) {
            addCriterion("buy_standard_no not like", value, "buyStandardNo");
            return (Criteria) this;
        }

        public Criteria andBuyStandardNoIn(List<String> values) {
            addCriterion("buy_standard_no in", values, "buyStandardNo");
            return (Criteria) this;
        }

        public Criteria andBuyStandardNoNotIn(List<String> values) {
            addCriterion("buy_standard_no not in", values, "buyStandardNo");
            return (Criteria) this;
        }

        public Criteria andBuyStandardNoBetween(String value1, String value2) {
            addCriterion("buy_standard_no between", value1, value2, "buyStandardNo");
            return (Criteria) this;
        }

        public Criteria andBuyStandardNoNotBetween(String value1, String value2) {
            addCriterion("buy_standard_no not between", value1, value2, "buyStandardNo");
            return (Criteria) this;
        }

        public Criteria andBuyBrandIsNull() {
            addCriterion("buy_brand is null");
            return (Criteria) this;
        }

        public Criteria andBuyBrandIsNotNull() {
            addCriterion("buy_brand is not null");
            return (Criteria) this;
        }

        public Criteria andBuyBrandEqualTo(String value) {
            addCriterion("buy_brand =", value, "buyBrand");
            return (Criteria) this;
        }

        public Criteria andBuyBrandNotEqualTo(String value) {
            addCriterion("buy_brand <>", value, "buyBrand");
            return (Criteria) this;
        }

        public Criteria andBuyBrandGreaterThan(String value) {
            addCriterion("buy_brand >", value, "buyBrand");
            return (Criteria) this;
        }

        public Criteria andBuyBrandGreaterThanOrEqualTo(String value) {
            addCriterion("buy_brand >=", value, "buyBrand");
            return (Criteria) this;
        }

        public Criteria andBuyBrandLessThan(String value) {
            addCriterion("buy_brand <", value, "buyBrand");
            return (Criteria) this;
        }

        public Criteria andBuyBrandLessThanOrEqualTo(String value) {
            addCriterion("buy_brand <=", value, "buyBrand");
            return (Criteria) this;
        }

        public Criteria andBuyBrandLike(String value) {
            addCriterion("buy_brand like", value, "buyBrand");
            return (Criteria) this;
        }

        public Criteria andBuyBrandNotLike(String value) {
            addCriterion("buy_brand not like", value, "buyBrand");
            return (Criteria) this;
        }

        public Criteria andBuyBrandIn(List<String> values) {
            addCriterion("buy_brand in", values, "buyBrand");
            return (Criteria) this;
        }

        public Criteria andBuyBrandNotIn(List<String> values) {
            addCriterion("buy_brand not in", values, "buyBrand");
            return (Criteria) this;
        }

        public Criteria andBuyBrandBetween(String value1, String value2) {
            addCriterion("buy_brand between", value1, value2, "buyBrand");
            return (Criteria) this;
        }

        public Criteria andBuyBrandNotBetween(String value1, String value2) {
            addCriterion("buy_brand not between", value1, value2, "buyBrand");
            return (Criteria) this;
        }

        public Criteria andPriceTypeIsNull() {
            addCriterion("price_type is null");
            return (Criteria) this;
        }

        public Criteria andPriceTypeIsNotNull() {
            addCriterion("price_type is not null");
            return (Criteria) this;
        }

        public Criteria andPriceTypeEqualTo(Integer value) {
            addCriterion("price_type =", value, "priceType");
            return (Criteria) this;
        }

        public Criteria andPriceTypeNotEqualTo(Integer value) {
            addCriterion("price_type <>", value, "priceType");
            return (Criteria) this;
        }

        public Criteria andPriceTypeGreaterThan(Integer value) {
            addCriterion("price_type >", value, "priceType");
            return (Criteria) this;
        }

        public Criteria andPriceTypeGreaterThanOrEqualTo(Integer value) {
            addCriterion("price_type >=", value, "priceType");
            return (Criteria) this;
        }

        public Criteria andPriceTypeLessThan(Integer value) {
            addCriterion("price_type <", value, "priceType");
            return (Criteria) this;
        }

        public Criteria andPriceTypeLessThanOrEqualTo(Integer value) {
            addCriterion("price_type <=", value, "priceType");
            return (Criteria) this;
        }

        public Criteria andPriceTypeIn(List<Integer> values) {
            addCriterion("price_type in", values, "priceType");
            return (Criteria) this;
        }

        public Criteria andPriceTypeNotIn(List<Integer> values) {
            addCriterion("price_type not in", values, "priceType");
            return (Criteria) this;
        }

        public Criteria andPriceTypeBetween(Integer value1, Integer value2) {
            addCriterion("price_type between", value1, value2, "priceType");
            return (Criteria) this;
        }

        public Criteria andPriceTypeNotBetween(Integer value1, Integer value2) {
            addCriterion("price_type not between", value1, value2, "priceType");
            return (Criteria) this;
        }

        public Criteria andDataTypeIsNull() {
            addCriterion("data_type is null");
            return (Criteria) this;
        }

        public Criteria andDataTypeIsNotNull() {
            addCriterion("data_type is not null");
            return (Criteria) this;
        }

        public Criteria andDataTypeEqualTo(Integer value) {
            addCriterion("data_type =", value, "dataType");
            return (Criteria) this;
        }

        public Criteria andDataTypeNotEqualTo(Integer value) {
            addCriterion("data_type <>", value, "dataType");
            return (Criteria) this;
        }

        public Criteria andDataTypeGreaterThan(Integer value) {
            addCriterion("data_type >", value, "dataType");
            return (Criteria) this;
        }

        public Criteria andDataTypeGreaterThanOrEqualTo(Integer value) {
            addCriterion("data_type >=", value, "dataType");
            return (Criteria) this;
        }

        public Criteria andDataTypeLessThan(Integer value) {
            addCriterion("data_type <", value, "dataType");
            return (Criteria) this;
        }

        public Criteria andDataTypeLessThanOrEqualTo(Integer value) {
            addCriterion("data_type <=", value, "dataType");
            return (Criteria) this;
        }

        public Criteria andDataTypeIn(List<Integer> values) {
            addCriterion("data_type in", values, "dataType");
            return (Criteria) this;
        }

        public Criteria andDataTypeNotIn(List<Integer> values) {
            addCriterion("data_type not in", values, "dataType");
            return (Criteria) this;
        }

        public Criteria andDataTypeBetween(Integer value1, Integer value2) {
            addCriterion("data_type between", value1, value2, "dataType");
            return (Criteria) this;
        }

        public Criteria andDataTypeNotBetween(Integer value1, Integer value2) {
            addCriterion("data_type not between", value1, value2, "dataType");
            return (Criteria) this;
        }

        public Criteria andDataUseTypeIsNull() {
            addCriterion("data_use_type is null");
            return (Criteria) this;
        }

        public Criteria andDataUseTypeIsNotNull() {
            addCriterion("data_use_type is not null");
            return (Criteria) this;
        }

        public Criteria andDataUseTypeEqualTo(Integer value) {
            addCriterion("data_use_type =", value, "dataUseType");
            return (Criteria) this;
        }

        public Criteria andDataUseTypeNotEqualTo(Integer value) {
            addCriterion("data_use_type <>", value, "dataUseType");
            return (Criteria) this;
        }

        public Criteria andDataUseTypeGreaterThan(Integer value) {
            addCriterion("data_use_type >", value, "dataUseType");
            return (Criteria) this;
        }

        public Criteria andDataUseTypeGreaterThanOrEqualTo(Integer value) {
            addCriterion("data_use_type >=", value, "dataUseType");
            return (Criteria) this;
        }

        public Criteria andDataUseTypeLessThan(Integer value) {
            addCriterion("data_use_type <", value, "dataUseType");
            return (Criteria) this;
        }

        public Criteria andDataUseTypeLessThanOrEqualTo(Integer value) {
            addCriterion("data_use_type <=", value, "dataUseType");
            return (Criteria) this;
        }

        public Criteria andDataUseTypeIn(List<Integer> values) {
            addCriterion("data_use_type in", values, "dataUseType");
            return (Criteria) this;
        }

        public Criteria andDataUseTypeNotIn(List<Integer> values) {
            addCriterion("data_use_type not in", values, "dataUseType");
            return (Criteria) this;
        }

        public Criteria andDataUseTypeBetween(Integer value1, Integer value2) {
            addCriterion("data_use_type between", value1, value2, "dataUseType");
            return (Criteria) this;
        }

        public Criteria andDataUseTypeNotBetween(Integer value1, Integer value2) {
            addCriterion("data_use_type not between", value1, value2, "dataUseType");
            return (Criteria) this;
        }

        public Criteria andSourceProCodeIsNull() {
            addCriterion("source_pro_code is null");
            return (Criteria) this;
        }

        public Criteria andSourceProCodeIsNotNull() {
            addCriterion("source_pro_code is not null");
            return (Criteria) this;
        }

        public Criteria andSourceProCodeEqualTo(String value) {
            addCriterion("source_pro_code =", value, "sourceProCode");
            return (Criteria) this;
        }

        public Criteria andSourceProCodeNotEqualTo(String value) {
            addCriterion("source_pro_code <>", value, "sourceProCode");
            return (Criteria) this;
        }

        public Criteria andSourceProCodeGreaterThan(String value) {
            addCriterion("source_pro_code >", value, "sourceProCode");
            return (Criteria) this;
        }

        public Criteria andSourceProCodeGreaterThanOrEqualTo(String value) {
            addCriterion("source_pro_code >=", value, "sourceProCode");
            return (Criteria) this;
        }

        public Criteria andSourceProCodeLessThan(String value) {
            addCriterion("source_pro_code <", value, "sourceProCode");
            return (Criteria) this;
        }

        public Criteria andSourceProCodeLessThanOrEqualTo(String value) {
            addCriterion("source_pro_code <=", value, "sourceProCode");
            return (Criteria) this;
        }

        public Criteria andSourceProCodeLike(String value) {
            addCriterion("source_pro_code like", value, "sourceProCode");
            return (Criteria) this;
        }

        public Criteria andSourceProCodeNotLike(String value) {
            addCriterion("source_pro_code not like", value, "sourceProCode");
            return (Criteria) this;
        }

        public Criteria andSourceProCodeIn(List<String> values) {
            addCriterion("source_pro_code in", values, "sourceProCode");
            return (Criteria) this;
        }

        public Criteria andSourceProCodeNotIn(List<String> values) {
            addCriterion("source_pro_code not in", values, "sourceProCode");
            return (Criteria) this;
        }

        public Criteria andSourceProCodeBetween(String value1, String value2) {
            addCriterion("source_pro_code between", value1, value2, "sourceProCode");
            return (Criteria) this;
        }

        public Criteria andSourceProCodeNotBetween(String value1, String value2) {
            addCriterion("source_pro_code not between", value1, value2, "sourceProCode");
            return (Criteria) this;
        }

        public Criteria andSourcePartIsNull() {
            addCriterion("source_part is null");
            return (Criteria) this;
        }

        public Criteria andSourcePartIsNotNull() {
            addCriterion("source_part is not null");
            return (Criteria) this;
        }

        public Criteria andSourcePartEqualTo(String value) {
            addCriterion("source_part =", value, "sourcePart");
            return (Criteria) this;
        }

        public Criteria andSourcePartNotEqualTo(String value) {
            addCriterion("source_part <>", value, "sourcePart");
            return (Criteria) this;
        }

        public Criteria andSourcePartGreaterThan(String value) {
            addCriterion("source_part >", value, "sourcePart");
            return (Criteria) this;
        }

        public Criteria andSourcePartGreaterThanOrEqualTo(String value) {
            addCriterion("source_part >=", value, "sourcePart");
            return (Criteria) this;
        }

        public Criteria andSourcePartLessThan(String value) {
            addCriterion("source_part <", value, "sourcePart");
            return (Criteria) this;
        }

        public Criteria andSourcePartLessThanOrEqualTo(String value) {
            addCriterion("source_part <=", value, "sourcePart");
            return (Criteria) this;
        }

        public Criteria andSourcePartLike(String value) {
            addCriterion("source_part like", value, "sourcePart");
            return (Criteria) this;
        }

        public Criteria andSourcePartNotLike(String value) {
            addCriterion("source_part not like", value, "sourcePart");
            return (Criteria) this;
        }

        public Criteria andSourcePartIn(List<String> values) {
            addCriterion("source_part in", values, "sourcePart");
            return (Criteria) this;
        }

        public Criteria andSourcePartNotIn(List<String> values) {
            addCriterion("source_part not in", values, "sourcePart");
            return (Criteria) this;
        }

        public Criteria andSourcePartBetween(String value1, String value2) {
            addCriterion("source_part between", value1, value2, "sourcePart");
            return (Criteria) this;
        }

        public Criteria andSourcePartNotBetween(String value1, String value2) {
            addCriterion("source_part not between", value1, value2, "sourcePart");
            return (Criteria) this;
        }

        public Criteria andGetDateIsNull() {
            addCriterion("get_date is null");
            return (Criteria) this;
        }

        public Criteria andGetDateIsNotNull() {
            addCriterion("get_date is not null");
            return (Criteria) this;
        }

        public Criteria andGetDateEqualTo(Date value) {
            addCriterion("get_date =", value, "getDate");
            return (Criteria) this;
        }

        public Criteria andGetDateNotEqualTo(Date value) {
            addCriterion("get_date <>", value, "getDate");
            return (Criteria) this;
        }

        public Criteria andGetDateGreaterThan(Date value) {
            addCriterion("get_date >", value, "getDate");
            return (Criteria) this;
        }

        public Criteria andGetDateGreaterThanOrEqualTo(Date value) {
            addCriterion("get_date >=", value, "getDate");
            return (Criteria) this;
        }

        public Criteria andGetDateLessThan(Date value) {
            addCriterion("get_date <", value, "getDate");
            return (Criteria) this;
        }

        public Criteria andGetDateLessThanOrEqualTo(Date value) {
            addCriterion("get_date <=", value, "getDate");
            return (Criteria) this;
        }

        public Criteria andGetDateIn(List<Date> values) {
            addCriterion("get_date in", values, "getDate");
            return (Criteria) this;
        }

        public Criteria andGetDateNotIn(List<Date> values) {
            addCriterion("get_date not in", values, "getDate");
            return (Criteria) this;
        }

        public Criteria andGetDateBetween(Date value1, Date value2) {
            addCriterion("get_date between", value1, value2, "getDate");
            return (Criteria) this;
        }

        public Criteria andGetDateNotBetween(Date value1, Date value2) {
            addCriterion("get_date not between", value1, value2, "getDate");
            return (Criteria) this;
        }

        public Criteria andGetUidIsNull() {
            addCriterion("get_uid is null");
            return (Criteria) this;
        }

        public Criteria andGetUidIsNotNull() {
            addCriterion("get_uid is not null");
            return (Criteria) this;
        }

        public Criteria andGetUidEqualTo(Integer value) {
            addCriterion("get_uid =", value, "getUid");
            return (Criteria) this;
        }

        public Criteria andGetUidNotEqualTo(Integer value) {
            addCriterion("get_uid <>", value, "getUid");
            return (Criteria) this;
        }

        public Criteria andGetUidGreaterThan(Integer value) {
            addCriterion("get_uid >", value, "getUid");
            return (Criteria) this;
        }

        public Criteria andGetUidGreaterThanOrEqualTo(Integer value) {
            addCriterion("get_uid >=", value, "getUid");
            return (Criteria) this;
        }

        public Criteria andGetUidLessThan(Integer value) {
            addCriterion("get_uid <", value, "getUid");
            return (Criteria) this;
        }

        public Criteria andGetUidLessThanOrEqualTo(Integer value) {
            addCriterion("get_uid <=", value, "getUid");
            return (Criteria) this;
        }

        public Criteria andGetUidIn(List<Integer> values) {
            addCriterion("get_uid in", values, "getUid");
            return (Criteria) this;
        }

        public Criteria andGetUidNotIn(List<Integer> values) {
            addCriterion("get_uid not in", values, "getUid");
            return (Criteria) this;
        }

        public Criteria andGetUidBetween(Integer value1, Integer value2) {
            addCriterion("get_uid between", value1, value2, "getUid");
            return (Criteria) this;
        }

        public Criteria andGetUidNotBetween(Integer value1, Integer value2) {
            addCriterion("get_uid not between", value1, value2, "getUid");
            return (Criteria) this;
        }

        public Criteria andPostNameIsNull() {
            addCriterion("post_name is null");
            return (Criteria) this;
        }

        public Criteria andPostNameIsNotNull() {
            addCriterion("post_name is not null");
            return (Criteria) this;
        }

        public Criteria andPostNameEqualTo(String value) {
            addCriterion("post_name =", value, "postName");
            return (Criteria) this;
        }

        public Criteria andPostNameNotEqualTo(String value) {
            addCriterion("post_name <>", value, "postName");
            return (Criteria) this;
        }

        public Criteria andPostNameGreaterThan(String value) {
            addCriterion("post_name >", value, "postName");
            return (Criteria) this;
        }

        public Criteria andPostNameGreaterThanOrEqualTo(String value) {
            addCriterion("post_name >=", value, "postName");
            return (Criteria) this;
        }

        public Criteria andPostNameLessThan(String value) {
            addCriterion("post_name <", value, "postName");
            return (Criteria) this;
        }

        public Criteria andPostNameLessThanOrEqualTo(String value) {
            addCriterion("post_name <=", value, "postName");
            return (Criteria) this;
        }

        public Criteria andPostNameLike(String value) {
            addCriterion("post_name like", value, "postName");
            return (Criteria) this;
        }

        public Criteria andPostNameNotLike(String value) {
            addCriterion("post_name not like", value, "postName");
            return (Criteria) this;
        }

        public Criteria andPostNameIn(List<String> values) {
            addCriterion("post_name in", values, "postName");
            return (Criteria) this;
        }

        public Criteria andPostNameNotIn(List<String> values) {
            addCriterion("post_name not in", values, "postName");
            return (Criteria) this;
        }

        public Criteria andPostNameBetween(String value1, String value2) {
            addCriterion("post_name between", value1, value2, "postName");
            return (Criteria) this;
        }

        public Criteria andPostNameNotBetween(String value1, String value2) {
            addCriterion("post_name not between", value1, value2, "postName");
            return (Criteria) this;
        }

        public Criteria andPostTelIsNull() {
            addCriterion("post_tel is null");
            return (Criteria) this;
        }

        public Criteria andPostTelIsNotNull() {
            addCriterion("post_tel is not null");
            return (Criteria) this;
        }

        public Criteria andPostTelEqualTo(String value) {
            addCriterion("post_tel =", value, "postTel");
            return (Criteria) this;
        }

        public Criteria andPostTelNotEqualTo(String value) {
            addCriterion("post_tel <>", value, "postTel");
            return (Criteria) this;
        }

        public Criteria andPostTelGreaterThan(String value) {
            addCriterion("post_tel >", value, "postTel");
            return (Criteria) this;
        }

        public Criteria andPostTelGreaterThanOrEqualTo(String value) {
            addCriterion("post_tel >=", value, "postTel");
            return (Criteria) this;
        }

        public Criteria andPostTelLessThan(String value) {
            addCriterion("post_tel <", value, "postTel");
            return (Criteria) this;
        }

        public Criteria andPostTelLessThanOrEqualTo(String value) {
            addCriterion("post_tel <=", value, "postTel");
            return (Criteria) this;
        }

        public Criteria andPostTelLike(String value) {
            addCriterion("post_tel like", value, "postTel");
            return (Criteria) this;
        }

        public Criteria andPostTelNotLike(String value) {
            addCriterion("post_tel not like", value, "postTel");
            return (Criteria) this;
        }

        public Criteria andPostTelIn(List<String> values) {
            addCriterion("post_tel in", values, "postTel");
            return (Criteria) this;
        }

        public Criteria andPostTelNotIn(List<String> values) {
            addCriterion("post_tel not in", values, "postTel");
            return (Criteria) this;
        }

        public Criteria andPostTelBetween(String value1, String value2) {
            addCriterion("post_tel between", value1, value2, "postTel");
            return (Criteria) this;
        }

        public Criteria andPostTelNotBetween(String value1, String value2) {
            addCriterion("post_tel not between", value1, value2, "postTel");
            return (Criteria) this;
        }

        public Criteria andPostDeptIsNull() {
            addCriterion("post_dept is null");
            return (Criteria) this;
        }

        public Criteria andPostDeptIsNotNull() {
            addCriterion("post_dept is not null");
            return (Criteria) this;
        }

        public Criteria andPostDeptEqualTo(String value) {
            addCriterion("post_dept =", value, "postDept");
            return (Criteria) this;
        }

        public Criteria andPostDeptNotEqualTo(String value) {
            addCriterion("post_dept <>", value, "postDept");
            return (Criteria) this;
        }

        public Criteria andPostDeptGreaterThan(String value) {
            addCriterion("post_dept >", value, "postDept");
            return (Criteria) this;
        }

        public Criteria andPostDeptGreaterThanOrEqualTo(String value) {
            addCriterion("post_dept >=", value, "postDept");
            return (Criteria) this;
        }

        public Criteria andPostDeptLessThan(String value) {
            addCriterion("post_dept <", value, "postDept");
            return (Criteria) this;
        }

        public Criteria andPostDeptLessThanOrEqualTo(String value) {
            addCriterion("post_dept <=", value, "postDept");
            return (Criteria) this;
        }

        public Criteria andPostDeptLike(String value) {
            addCriterion("post_dept like", value, "postDept");
            return (Criteria) this;
        }

        public Criteria andPostDeptNotLike(String value) {
            addCriterion("post_dept not like", value, "postDept");
            return (Criteria) this;
        }

        public Criteria andPostDeptIn(List<String> values) {
            addCriterion("post_dept in", values, "postDept");
            return (Criteria) this;
        }

        public Criteria andPostDeptNotIn(List<String> values) {
            addCriterion("post_dept not in", values, "postDept");
            return (Criteria) this;
        }

        public Criteria andPostDeptBetween(String value1, String value2) {
            addCriterion("post_dept between", value1, value2, "postDept");
            return (Criteria) this;
        }

        public Criteria andPostDeptNotBetween(String value1, String value2) {
            addCriterion("post_dept not between", value1, value2, "postDept");
            return (Criteria) this;
        }

        public Criteria andIsEffectiveFlagIsNull() {
            addCriterion("is_effective_flag is null");
            return (Criteria) this;
        }

        public Criteria andIsEffectiveFlagIsNotNull() {
            addCriterion("is_effective_flag is not null");
            return (Criteria) this;
        }

        public Criteria andIsEffectiveFlagEqualTo(Integer value) {
            addCriterion("is_effective_flag =", value, "isEffectiveFlag");
            return (Criteria) this;
        }

        public Criteria andIsEffectiveFlagNotEqualTo(Integer value) {
            addCriterion("is_effective_flag <>", value, "isEffectiveFlag");
            return (Criteria) this;
        }

        public Criteria andIsEffectiveFlagGreaterThan(Integer value) {
            addCriterion("is_effective_flag >", value, "isEffectiveFlag");
            return (Criteria) this;
        }

        public Criteria andIsEffectiveFlagGreaterThanOrEqualTo(Integer value) {
            addCriterion("is_effective_flag >=", value, "isEffectiveFlag");
            return (Criteria) this;
        }

        public Criteria andIsEffectiveFlagLessThan(Integer value) {
            addCriterion("is_effective_flag <", value, "isEffectiveFlag");
            return (Criteria) this;
        }

        public Criteria andIsEffectiveFlagLessThanOrEqualTo(Integer value) {
            addCriterion("is_effective_flag <=", value, "isEffectiveFlag");
            return (Criteria) this;
        }

        public Criteria andIsEffectiveFlagIn(List<Integer> values) {
            addCriterion("is_effective_flag in", values, "isEffectiveFlag");
            return (Criteria) this;
        }

        public Criteria andIsEffectiveFlagNotIn(List<Integer> values) {
            addCriterion("is_effective_flag not in", values, "isEffectiveFlag");
            return (Criteria) this;
        }

        public Criteria andIsEffectiveFlagBetween(Integer value1, Integer value2) {
            addCriterion("is_effective_flag between", value1, value2, "isEffectiveFlag");
            return (Criteria) this;
        }

        public Criteria andIsEffectiveFlagNotBetween(Integer value1, Integer value2) {
            addCriterion("is_effective_flag not between", value1, value2, "isEffectiveFlag");
            return (Criteria) this;
        }

        public Criteria andCostIdIsNull() {
            addCriterion("cost_id is null");
            return (Criteria) this;
        }

        public Criteria andCostIdIsNotNull() {
            addCriterion("cost_id is not null");
            return (Criteria) this;
        }

        public Criteria andCostIdEqualTo(Integer value) {
            addCriterion("cost_id =", value, "costId");
            return (Criteria) this;
        }

        public Criteria andCostIdNotEqualTo(Integer value) {
            addCriterion("cost_id <>", value, "costId");
            return (Criteria) this;
        }

        public Criteria andCostIdGreaterThan(Integer value) {
            addCriterion("cost_id >", value, "costId");
            return (Criteria) this;
        }

        public Criteria andCostIdGreaterThanOrEqualTo(Integer value) {
            addCriterion("cost_id >=", value, "costId");
            return (Criteria) this;
        }

        public Criteria andCostIdLessThan(Integer value) {
            addCriterion("cost_id <", value, "costId");
            return (Criteria) this;
        }

        public Criteria andCostIdLessThanOrEqualTo(Integer value) {
            addCriterion("cost_id <=", value, "costId");
            return (Criteria) this;
        }

        public Criteria andCostIdIn(List<Integer> values) {
            addCriterion("cost_id in", values, "costId");
            return (Criteria) this;
        }

        public Criteria andCostIdNotIn(List<Integer> values) {
            addCriterion("cost_id not in", values, "costId");
            return (Criteria) this;
        }

        public Criteria andCostIdBetween(Integer value1, Integer value2) {
            addCriterion("cost_id between", value1, value2, "costId");
            return (Criteria) this;
        }

        public Criteria andCostIdNotBetween(Integer value1, Integer value2) {
            addCriterion("cost_id not between", value1, value2, "costId");
            return (Criteria) this;
        }

        public Criteria andIsPrototypeDataFlagIsNull() {
            addCriterion("is_prototype_data_flag is null");
            return (Criteria) this;
        }

        public Criteria andIsPrototypeDataFlagIsNotNull() {
            addCriterion("is_prototype_data_flag is not null");
            return (Criteria) this;
        }

        public Criteria andIsPrototypeDataFlagEqualTo(Integer value) {
            addCriterion("is_prototype_data_flag =", value, "isPrototypeDataFlag");
            return (Criteria) this;
        }

        public Criteria andIsPrototypeDataFlagNotEqualTo(Integer value) {
            addCriterion("is_prototype_data_flag <>", value, "isPrototypeDataFlag");
            return (Criteria) this;
        }

        public Criteria andIsPrototypeDataFlagGreaterThan(Integer value) {
            addCriterion("is_prototype_data_flag >", value, "isPrototypeDataFlag");
            return (Criteria) this;
        }

        public Criteria andIsPrototypeDataFlagGreaterThanOrEqualTo(Integer value) {
            addCriterion("is_prototype_data_flag >=", value, "isPrototypeDataFlag");
            return (Criteria) this;
        }

        public Criteria andIsPrototypeDataFlagLessThan(Integer value) {
            addCriterion("is_prototype_data_flag <", value, "isPrototypeDataFlag");
            return (Criteria) this;
        }

        public Criteria andIsPrototypeDataFlagLessThanOrEqualTo(Integer value) {
            addCriterion("is_prototype_data_flag <=", value, "isPrototypeDataFlag");
            return (Criteria) this;
        }

        public Criteria andIsPrototypeDataFlagIn(List<Integer> values) {
            addCriterion("is_prototype_data_flag in", values, "isPrototypeDataFlag");
            return (Criteria) this;
        }

        public Criteria andIsPrototypeDataFlagNotIn(List<Integer> values) {
            addCriterion("is_prototype_data_flag not in", values, "isPrototypeDataFlag");
            return (Criteria) this;
        }

        public Criteria andIsPrototypeDataFlagBetween(Integer value1, Integer value2) {
            addCriterion("is_prototype_data_flag between", value1, value2, "isPrototypeDataFlag");
            return (Criteria) this;
        }

        public Criteria andIsPrototypeDataFlagNotBetween(Integer value1, Integer value2) {
            addCriterion("is_prototype_data_flag not between", value1, value2, "isPrototypeDataFlag");
            return (Criteria) this;
        }
    }

    public static class Criteria extends GeneratedCriteria {

        protected Criteria() {
            super();
        }
    }

    public static class Criterion {
        private String condition;

        private Object value;

        private Object secondValue;

        private boolean noValue;

        private boolean singleValue;

        private boolean betweenValue;

        private boolean listValue;

        private String typeHandler;

        public String getCondition() {
            return condition;
        }

        public Object getValue() {
            return value;
        }

        public Object getSecondValue() {
            return secondValue;
        }

        public boolean isNoValue() {
            return noValue;
        }

        public boolean isSingleValue() {
            return singleValue;
        }

        public boolean isBetweenValue() {
            return betweenValue;
        }

        public boolean isListValue() {
            return listValue;
        }

        public String getTypeHandler() {
            return typeHandler;
        }

        protected Criterion(String condition) {
            super();
            this.condition = condition;
            this.typeHandler = null;
            this.noValue = true;
        }

        protected Criterion(String condition, Object value, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.typeHandler = typeHandler;
            if (value instanceof List<?>) {
                this.listValue = true;
            } else {
                this.singleValue = true;
            }
        }

        protected Criterion(String condition, Object value) {
            this(condition, value, null);
        }

        protected Criterion(String condition, Object value, Object secondValue, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.secondValue = secondValue;
            this.typeHandler = typeHandler;
            this.betweenValue = true;
        }

        protected Criterion(String condition, Object value, Object secondValue) {
            this(condition, value, secondValue, null);
        }
    }
}